Implementation of Model-View-Controller Architecture Pattern for Business Intelligence Architecture

This paper presents a new approach to develop the strategy of Model–View–Controller architecture pattern in Business Intelligence (BI) architecture. The Business Intelligence architecture consists of the ETL tools and processes, the data warehouse, the technical infrastructure, and the user-interface tools. The major issue related to Business Intelligence architecture is to store the data from heterogeneous sources. The heterogeneous sources might lead to inconsistencies in storage and retrieval of data. Another issue related to Business Intelligence architecture is to provide multiple and synchronized views. The Business information must be presentable in various formats with 'look and feel' approach. Model-View-Controller provides independent approach to the components of Business Intelligence architecture. Model provides guideline for storing the heterogeneous data in one format and implements core functionality of the system. View provides multiple and synchronized views so that information can be available in presentable format. Controller handles user's input. All the three independent components are tightly coupled which ensures consistent and flexible Business Intelligence architecture.